
-- Project: Lazarus
-- Table and Relationship creation scripts.
      
      -- Table Deletion

SET ANSI_NULLS ON 
GO


/*
Table Deletion -- ExpertiseLevel

Specifies the levels of expertise you may have in a current technology.
*/
IF ( EXISTS( SELECT syso.id FROM sysobjects syso WHERE syso.type = 'U' AND syso.name = 'tblExpertiseLevel' ) )
DROP TABLE dbo.[tblExpertiseLevel];

/*
Table Deletion -- Technology

Specifies a technology for which you are tracking competency.
*/
IF ( EXISTS( SELECT syso.id FROM sysobjects syso WHERE syso.type = 'U' AND syso.name = 'tblTechnology' ) )
DROP TABLE dbo.[tblTechnology];

/*
Table Deletion -- GoalStatus

Specifies a technology for which you are tracking competency.
*/
IF ( EXISTS( SELECT syso.id FROM sysobjects syso WHERE syso.type = 'U' AND syso.name = 'tblGoalStatus' ) )
DROP TABLE dbo.[tblGoalStatus];

/*
Table Deletion -- Goal

Defines a goal or milestone.  This may involve one or more of your chosen Technology Focuses.
*/
IF ( EXISTS( SELECT syso.id FROM sysobjects syso WHERE syso.type = 'U' AND syso.name = 'tblGoal' ) )
DROP TABLE dbo.[tblGoal];

/*
Table Deletion -- GoalRequiredExpertise

Defines which Technology Focuses are is required to satisfy your various goals.
*/
IF ( EXISTS( SELECT syso.id FROM sysobjects syso WHERE syso.type = 'U' AND syso.name = 'tblGoalRequiredExpertise' ) )
DROP TABLE dbo.[tblGoalRequiredExpertise];

      
GO

SET ANSI_NULLS OFF
   